exp gsms/any02gs@eu-anydb file="pmt.dmp" tables="G_PMGM_MST G_PMGM_MST_SITE G_PMGM_MST_SUB G_PMGM_MST_TARGET"

sqlplus gsms/any02gs@oraeu << EOF
    truncate table G_PMGM_MST;
    truncate table G_PMGM_MST_SITE;
    truncate table G_PMGM_MST_SUB;
    truncate table G_PMGM_MST_TARGET;
    commit;
    exit;
EOF

imp gsms/any02gs@oraeu file="pmt.dmp" ignore=y

rm pmt.dmp

sqlplus gsms/any02gs@oraeu << EOF
    update g_pmgm_mst set status_cd='O' where status_cd='P';
    commit;
    exit;
EOF
